DECLARE @cCompanyID VARCHAR (25)
SET @cCompanyID = '400-00'

DELETE FROM system_option WHERE cCompanyID =@cCompanyID AND cCode IN ('CLNT_OPT_REQUESTEDTO',
			'CLNT_OPT_BRANCH','CLNT_OPT_VENDORCODE','CLNT_OPT_CONSIGNEEID','ITM_VIS_LASTORDERED',
			'ITM_VIS_CONSUMED','ITM_VIS_BALANCE','ITM_VIS_QTYAPPROVED')

DELETE FROM parameter_user WHERE cCompanyID = @cCompanyID AND cType = 'ITEMUNIT'


INSERT INTO parameter_user (cCompanyID,cType,cParamName,cModule,cDesc,cValue,nOrder)
VALUES (@cCompanyID,'ITEMUNIT','PCS',NULL,'PCS',1,1)

INSERT INTO parameter_user (cCompanyID,cType,cParamName,cModule,cDesc,cValue,nOrder)
VALUES (@cCompanyID,'ITEMUNIT','PCK',NULL,'PCK',2,2)

INSERT INTO parameter_user (cCompanyID,cType,cParamName,cModule,cDesc,cValue,nOrder)
VALUES (@cCompanyID,'ITEMUNIT','SET',NULL,'SET',3,3)

INSERT INTO parameter_user (cCompanyID,cType,cParamName,cModule,cDesc,cValue,nOrder)
VALUES (@cCompanyID,'ITEMUNIT','PAIR',NULL,'PAIR',4,4)

INSERT INTO system_option(cCompanyID,cCode,cFormName,lBit,cValue)
VALUES(@cCompanyID,'CLNT_OPT_REQUESTEDTO', 'CLIENT','0','Requested To')

INSERT INTO system_option(cCompanyID,cCode,cFormName,lBit,cValue)
VALUES(@cCompanyID,'CLNT_OPT_BRANCH', 'CLIENT','0','Branch')

INSERT INTO system_option(cCompanyID,cCode,cFormName,lBit,cValue)
VALUES(@cCompanyID,'CLNT_OPT_VENDORCODE', 'CLIENT','0','Vendor Code')

INSERT INTO system_option(cCompanyID,cCode,cFormName,lBit,cValue)
VALUES(@cCompanyID,'CLNT_OPT_CONSIGNEEID', 'CLIENT','0','Consignee ID')

INSERT INTO system_option(cCompanyID,cCode,cFormName,lBit,cValue)
VALUES(@cCompanyID,'ITM_VIS_LASTORDERED', 'ITEM','0','LAST ORDERED')

INSERT INTO system_option(cCompanyID,cCode,cFormName,lBit,cValue)
VALUES(@cCompanyID,'ITM_VIS_CONSUMED', 'ITEM','0','CONSUMED')

INSERT INTO system_option(cCompanyID,cCode,cFormName,lBit,cValue)
VALUES(@cCompanyID,'ITM_VIS_BALANCE', 'ITEM','0','BALANCE')

INSERT INTO system_option(cCompanyID,cCode,cFormName,lBit,cValue)
VALUES(@cCompanyID,'ITM_VIS_QTYAPPROVED', 'ITEM','0','CONSUMED')
